home *** CD-ROM | disk | FTP | other *** search
- ================================================================
- EXCEL.DOC
- ================================================================
-
- This document deals with conversion of features from Excel 2.1,
- 3.0, and 4.0 to WordPerfect 6.0. Currently, converting tables
- from WordPerfect 6.0 to Excel is not supported.
-
-
- ================================================================
- Section 1 - Excel 2.1, 3.0 and 4.0 to WordPerfect 6.0
- ================================================================
-
- The following table shows how codes are converted from Excel
- format to WordPerfect 6.0.
-
- EXCEL 2.1, 3.0 and 4.0 WORDPERFECT 6.0
- ====================== ===========
-
- Alignment
-
- Center Center
-
- Enter/Tab Not Applicable
-
- Fill Left Align, repeat characters
- until cell full
-
- General Right align if number, all
- else Left
-
- Justify Left and Right
-
- Left Left
-
- Right Right
-
- Wrap text Cells won't combine for long
- text
-
- Charts Charts not supported
-
- File
-
- Page Set-up
-
- Footer Footer - except if imported
- into an existing WordPerfect
- 6.0 document
-
- Header Header - except if imported
- into an existing WordPerfect
- 6.0 document
-
- Margins-Bottom Bottom Margin
-
- Margins-Top Top Margin
-
- Margins-Left Left Margin
-
- Margins-Right Right Margin
-
- Orientation-Landscape Landscape
-
- Orientation-Portrait Portrait
-
- Paper Size Paper Size
-
- Format
-
- Auto Format Not Applicable
-
- Border Not Converted
-
- Cell Protection
-
- Hidden Hidden (except blank cells)
-
- Locked Locked (except blank cells)
-
- Center across section Center
-
- Column Width
-
- Best fit Maintains column width
-
- Hide Hidden
-
- UnHide Show all Hidden Text
-
- Width Column: Width #8
-
- Font
-
- Color Color
-
- Effect Underline Underline
-
- Effect Strikeout Strikeout
-
- Name Converts as close as possible
-
- Size Size
-
- Style Bold Italic Bold Italic
-
- Style Bold Bold
-
- Style Italic Italic
-
- Style Regular Normal
-
- Justify Left and Right Align
-
- Number
-
- All/General General
-
- Currency Currency
-
- Date Date Type Formats
-
- Fraction General, rounds to whole
- number
-
- Number Fixed
-
- Percent Percent
-
- Scientific Scientific
-
- Time Date/Time Formats
-
- Patterns
-
- Background 10% Shade Fill
-
- Cell Shading 10% Shade Fill
-
- Foreground 10% Shade Fill
-
- Row Height
-
- Hide Hidden
-
- Non Standard Row Height
-
- Standard Row Height
-
- UnHide Show all Hidden Text
-
- Style Not Applicable
-
- Text orientation Horizontal only is converted
-
- Vertical Center Not Converted
-
- Vertical Bottom Not Converted
-
- Vertical Top Not Converted
-
- Functions Please see list of supported
- functions in Section 2
-
- Macros Not Converted
-
- Options
-
- Calculation Not Converted
-
- Protect Document Cannot convert if password is
- set
-
- Set Page Break Horizontal Page Breaks
-
-
- Importing spreadsheets up to 64 columns is supported. If you try
- to import a spreadsheet with more than 64 columns, all columns
- after the 64th column are truncated.
-
- Importing a spreadsheet into a WordPerfect 6.0 document changes
- the Table Line defaults for all following tables to "None."
- Tables following the imported spreadsheet will need to be edited
- and changed to restore the table lines and borders.
-
- Range names longer than 25 characters are not converted.
-
- Hidden cells convert unhidden.
-
- Vertically aligned text will convert as horizontal.
-
- Border line draw will convert to default table lines.
-
- Hidden columns will convert to a column width of .001. Changing
- the column width in WordPerfect 6.0 will expand hidden columns.
-
-
- ================================================================
- Section 2 - Excel Function Codes
- ================================================================
-
- The following table shows Excel Functions and how they convert to
- WordPerfect 6.0.
-
- EXCEL FUNCTIONS WordPerfect 6.0
- =============== ===============
-
- ABS() ABS()
-
- ACCRINT() Not converted
-
- ACCRINTM() Not converted
-
- ACOS() ACOS()
-
- ACOSH() Not converted
-
- ADDRESS() Not converted
-
- AND() AND()
-
- AREAS() Not converted
-
- ASIN() ASIN()
-
- ASINH() Not converted
-
- ATAN() ATAN()
-
- ATAN2() ATAN2()
-
- ATANH() Not converted
-
- AVERAGE() AVE()
-
- BASE() Not converted
-
- BESSELI() Not converted
-
- BESSELJ() Not converted
-
- BESSELK() Not converted
-
- BESSELY() Not converted
-
- BETADIST() Not converted
-
- BETAINV() Not converted
-
- BIN2DEC() Not converted
-
- BIN2HEX() Not converted
-
- BIN2OCT() Not converted
-
- BINOMDIST() Not converted
-
- CALL() Not converted
-
- CEILING() Not converted
-
- CELL() Not converted
-
- CHAR() CHAR()
-
- CHIDIST() Not converted
-
- CHIINV() Not converted
-
- CHITEST() Not converted
-
- CHOOSE() CHOOSE()
-
- CLEAN() Not converted
-
- CODE() Not converted
-
- COLUMN() Column (arguments) is not
- supported
-
- COLUMNS() Not converted
-
- COMBIN() Not converted
-
- COMPLEX() Not converted
-
- CONFIDENCE() Not converted
-
- CONVERT() Not converted
-
- CORREL() Not converted
-
- COS() COS()
-
- COSH() Not converted
-
- COUNT() COUNT()
-
- COUNTA() COUNT()
-
- COUPDAYBS() Not converted
-
- COUPDAYS() Not converted
-
- COUPDAYSNC() Not converted
-
- COUPNCD() Not converted
-
- COUPNUM() Not converted
-
- COUPPCD() Not converted
-
- COVAR() Not converted
-
- CRITBINOM() Not converted
-
- CROSSTAB() Not converted
-
- CUMIPMT() Not converted
-
- CUMPRINC() Not converted
-
- DATE() DATE()
-
- DATEVALUE() DATEVALUE()
-
- DAVERAGE() Not converted
-
- DAY() DAY()
-
- DAYS360() Not converted
-
- DB() Not converted
-
- DCOUNT() Not converted
-
- DCOUNTA() Not converted
-
- DDB() DDB()
-
- DEC2BIN() Not converted
-
- DEC2HEX() Not converted
-
- DEC2OCT() Not converted
-
- DELTA() Not converted
-
- DEVSQ() Not converted
-
- DGET() Not converted
-
- DISC() Not converted
-
- DMAX() Not converted
-
- DMIN() Not converted
-
- DOLLAR() CURRENCY()
-
- DOLLARDE() Not converted
-
- DOLLARFR() Not converted
-
- DPRODUCT() Not converted
-
- DSTDEV() Not converted
-
- DSTDEVP() Not converted
-
- DSUM() Not converted
-
- DURATION() Not converted
-
- DVAR() Not converted
-
- DVARP() Not converted
-
- EDATE() Not converted
-
- EFFECT() Not converted
-
- EOMONTH() Not converted
-
- ERF() Not converted
-
- ERFC() Not converted
-
- ERROR.TYPE() Not converted
-
- EVEN() Not converted
-
- EXACT() Not converted
-
- EXP() EXP()
-
- EXPONDIST() Not converted
-
- FACT() FACT()
-
- FACTDOUBLE() Not converted
-
- FALSE() FALSE()
-
- FDIST() Not converted
-
- FIND() FIND()
-
- FINV() Not converted
-
- FISHER() Not converted
-
- FISHERINV() Not converted
-
- FIXED() TEXT()
-
- FLOOR() Not converted
-
- FORECAST() Not converted
-
- FREQUENCY() Not converted
-
- FTEST() Not converted
-
- FV() FV()
-
- FVSCHEDULE() Not converted
-
- GAMMADIST() Not converted
-
- GAMMAINV() Not converted
-
- GAMMALN() Not converted
-
- GCD() Not converted
-
- GEOMEAN() Not converted
-
- GESTEP() Not converted
-
- GROWTH() Not converted
-
- HARMEAN() Not converted
-
- HEX2BIN() Not converted
-
- HEX2DEC() Not converted
-
- HEX2OCT() Not converted
-
- HLOOKUP() LOOKUP()
-
- HOUR() HOUR()
-
- HYPGEOMDIST() Not converted
-
- IF() IF()
-
- IMABS() Not converted
-
- IMAGINARY() Not converted
-
- IMARGUMENT() Not converted
-
- IMCONJUGATE() Not converted
-
- IMCOS() Not converted
-
- IMDIV() Not converted
-
- IMEXP() Not converted
-
- IMLN() Not converted
-
- IMLOG10() Not converted
-
- IMLOG2() Not converted
-
- IMPOWER() Not converted
-
- IMPRODUCT() Not converted
-
- IMREAL() Not converted
-
- IMSIN() Not converted
-
- IMSQRT() Not converted
-
- IMSUB() Not converted
-
- IMSUM() Not converted
-
- INDEX() INDEX()
-
- INDIRECT() Not converted
-
- INFO() Not converted
-
- INT() INT()
-
- INTERCEPT() Not converted
-
- INTRATE() Not converted
-
- IPMT() Not converted
-
- IRR() IRR()
-
- ISBLANK() ISNA()
-
- ISERR() ISERR()
-
- ISERROR() ISERR()
-
- ISEVEN() Not converted
-
- ISLOGICAL() ISVALUE()
-
- ISNA() ISNA()
-
- ISNONTEXT() ISTEXT
-
- ISNUMBER() ISVALUE()
-
- ISODD() Not converted
-
- ISREF() Not converted
-
- ISTEXT() ISTEXT()
-
- KURT() Not converted
-
- LARGE() Not converted
-
- LCM() Not converted
-
- LEFT() LEFT()
-
- LEN() LENGTH()
-
- LINEST() Not converted
-
- LN() LN()
-
- LOG() LOG()
-
- LOG10() LOG10()
-
- LOGEST() Not converted
-
- LOGINV() Not converted
-
- LOGNORMDIST() Not converted
-
- LOOKUP() LOOKUP()
-
- LOWER() LOWER()
-
- MATCH() MATCH()
-
- MAX() MAX()
-
- MDETERM() Not converted
-
- MDURATION() Not converted
-
- MEDIAN() Not converted
-
- MID() MID()
-
- MIN() MIN()
-
- MINUTE() MINUTE()
-
- MINVERSE() Not converted
-
- MIRR() Not converted
-
- MMULT() Not converted
-
- MOD() MOD()
-
- MODE() Not converted
-
- MONTH() MONTH()
-
- MROUND() Not converted
-
- MULTINOMIAL() Not converted
-
- N() Not converted
-
- NA() NA()
-
- NEGBINOMDIST() Not converted
-
- NETWORKDAYS() Not converted
-
- NOMINAL() Not converted
-
- NORMDIST() Not converted
-
- NORMINV() Not converted
-
- NORMSDIST() Not converted
-
- NORMSINV() Not converted
-
- NOT() NOT()
-
- NOW() MDY() + HMS()
-
- NPER() TERM()
-
- NPV() NPV()
-
- OCT2BIN() Not converted
-
- OCT2DEC() Not converted
-
- OCT2HEX() Not converted
-
- ODD() Not converted
-
- ODDFPRICE() Not converted
-
- ODDFYIELD() Not converted
-
- ODDLPRICE() Not converted
-
- ODDLYIELD() Not converted
-
- OFFSET() Not converted
-
- OR() OR()
-
- PEARSON() Not converted
-
- PERCENTILE() Not converted
-
- PERCENTRANK() Not converted
-
- PERMUT() Not converted
-
- PI() PI()
-
- PMT() PMT()
-
- POISSON() Not converted
-
- PPMT() Not converted
-
- PRICE() Not converted
-
- PRICEDISC() Not converted
-
- PRICEMAT() Not converted
-
- PROB() Not converted
-
- PRODUCT() PRODUCT()
-
- PROPER() PROPER()
-
- PV() PV()
-
- QUARTILE () Not converted
-
- QUOTIENT() Not converted
-
- RAND() RANDOM()
-
- RANK() Not converted
-
- RATE() RATE()
-
- RECEIVED() Not converted
-
- REGISTER() Not converted
-
- REPLACE() Not converted
-
- REPT() REPEAT()
-
- RIGHT() RIGHT()
-
- ROUND() ROUND()
-
- ROW() ROW (arguments) is not
- supported.
-
- ROWS() Not converted
-
- RSQ() Not converted
-
- SEARCH() Not converted
-
- SECOND() SECOND()
-
- SERIESSUM() Not converted
-
- SIGN() SIGN
-
- SIN() SIN()
-
- SINH() Not converted
-
- SKEW() Not converted
-
- SLN() SLN()
-
- SLOPE() Not converted
-
- SMALL() Not converted
-
- SQRT() SQRT()
-
- SQRTPI() Not converted
-
- STANDARDIZE() Not converted
-
- STDEV() STDEV()
-
- STDEVP() STDEVP()
-
- STEYX() Not converted
-
- SUBSTITUTE() Not converted
-
- SUM() SUM()
-
- SUMPRODUCT() Not converted
-
- SUMSQ() SUM()
-
- SUMX2MY2() Not converted
-
- SUMX2PY2() Not converted
-
- SUMXMY2() Not converted
-
- SYD() SYD()
-
- T() Not converted
-
- TAN() TAN()
-
- TANH() Not converted
-
- TBILLEQ() Not converted
-
- TBILLPRICE() Not converted
-
- TBILLYIELD() Not converted
-
- TDIST() Not converted
-
- TEXT() Not converted
-
- TIME() TIME()
-
- TIMEVALUE() TIMEVALUE()
-
- TINV() Not converted
-
- TODAY() MDY()
-
- TRANSPOSE() Not converted
-
- TREND() Not converted
-
- TRIM() Not converted
-
- TRIMMEAN() Not converted
-
- TRUE() TRUE()
-
- TRUNC() INT()
-
- TTEST() Not converted
-
- TYPE() Not converted
-
- UPPER() UPPER()
-
- VALUE() VALUE()
-
- VAR() VAR()
-
- VARP() VARP()
-
- VDB() Not converted
-
- VLOOKUP() LOOKUP()
-
- WEEKDAY() ((arg) % 7 + 1) if arg is
- cell reference
- (Date value (arg) % 7 + 1) if
- a string
-
- WEIBULL() Not converted
-
- WORKDAY() Not converted
-
- XIRR() Not converted
-
- XNPV() Not converted
-
- YEAR() YEAR()
-
- YEARFRAC() Not converted
-
- YIELD() Not converted
-
- YIELDDISC() Not converted
-
- YIELDMAT() Not converted
-
- ZTEST() Not converted